SUPPORT / SAMPLES & SAS NOTES
Problem Note 38458: SQLPLAN internal errors might occur when you reference a view in a query that has variables that are defined with the the LENGTH= column modifier
 |  |  |  |  |
In Base SAS® software, SQLPLAN internal errors might occur when the following events take place:
- You reference a view that has variables that are defined with the LENGTH= modifier.
- In an SQL procedure query, you reference calculated variables that were created earlier in the query and you reference an additional variable with a LENGTH= modifier.
The following code illustrates one case that can produce the SQLPLAN internal errors:
proc sql;
create view v1 as
select x length=7, y length=8
from test;
create table results as
select y length=8,
case when upcase(x) contains "VD" and upcase(x) not contains "VICE" then 1 else 0
end as _VD ,
max(case when calculated _VD then 1 else . end) as cnts ,
case when upcase(x) contains "LEDAM" then 1 else .
end as _LEDAM,
count(calculated _LEDAM) as _NumLEDAM
from v1;
quit;
In this case, the following error messages are generated:
ERROR: sqlplan internal error: Cannot find symbol _VD, var=2,
tag=0001. This message can be caused by attempting to
make correlated references between two different items
on a single FROM clause.
ERROR: sqlplan internal error: Cannot find symbol _VD, var=2,
tag=0001. This message can be caused by attempting to
make correlated references between two different items
on a single FROM clause.
ERROR: sqlplan internal error: Cannot find symbol #TEMA001,
var=8, tag=0001. This message can be caused by
attempting to make correlated references between two
different items on a single FROM clause.
Currently, there is no solution or workaround for this problem.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | z/OS | 9.1 TS1M3 SP4 | 9.2 TS2M3 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Server | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 SP4 | |||
| Microsoft Windows NT Workstation | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Windows Vista | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| HP-UX IPF | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Linux | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Linux on Itanium | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| OpenVMS Alpha | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Solaris for x64 | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||
| Tru64 UNIX | 9.1 TS1M3 SP4 | 9.2 TS2M3 | ||